Information for tables that are currently loading
This section displays a table with information for each of the tables that are currently loading. To view this table, click the Loading bar, shown in the figure below.
When replicating to an Oracle database with a full disk and/or partition where Oracle is trying to write archived redo log files, insert operations may fail. In such as case, no error will be shown and the task will not progress past the loading stage. To confirm that this is indeed an Oracle Archiver error, stop and attempt to restart the task. The task will not start and an appropriate error should be shown.
The information is displayed in a table that has the following columns:
- Table Name: The names of the source tables that are currently loading.
- Load Duration: The amount of time that it took for all records to load to the current point in time.
- Estimated Count: The estimated number of rows that are to be loaded in the full load operation.
-
Transferred Count: The number of records that are loaded to the target endpoint.
- Current Throughput: The current throughput rate for the table. Throughput describes the number of records read per second. For more information on throughput, see Monitoring throughput in a Full Load operation.
- Cached Changes (not relevant for Full Load only tasks) - The number of changes (DMLs) applied to the source table since the Replicate started loading the table to the target.
-
Estimated Finish Time: The approximate time the task finished loading the tables. The timestamp displayed indicates the date and time.
Information noteThere may sometimes be a discrepancy between the "Estimated Finish Time" and the"Time Remaining (Estimated)" values.
The "Time Remaining (Estimated)" value is calculated by the combined transfer rate of all the records of the task, while the "Estimated Finish Time" is calculated per table.
The discrepancy arises when the table transfer rate at the beginning of the task is very fast, but slows down towards the end of the task.
In this situation, the "Time Remaining (Estimated)" value will be greater and less accurate than the "Estimated Finish Time" value.
- Progress: The table status and the time the table entered that status.
- Reload: Click the Reload icon to reload the data for selected tables and run the full-load operation again.
When filters are applied to source tables, the number shown in this column will reflect the total number of records before the include/exclude filter was applied. Consequently, the "Transferred Count" number may be higher than the actual number of records that were replicated to the target.